package com.zte.market.mapper;

import com.zte.market.pojo.Province;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ProvinceMapper {

    /*
    *  查找所有的省
    * @return province
    * */
    public List<Province> queryProvinces();

    /*
     *  根据省名查省ID
     * @return Integer
     * */
    public Integer queryProvinceId(@Param("pName")String pName);

    /*
     *  根据市名查省名
     * @return Integer
     * */
    public Integer queryProvinceName(@Param("cName")String cName);

    /**
     * 通过 id 查询 省 信息
     * @param id
     * @return
     */
    Province queryById(@Param("id") Integer id );


}
